Spreadsheet Models for Cataloging Statistics

Evaluating refactorings for spreadsheet models

Software refactoring is a well-known technique that provides transformations on software artifacts with the aim of improving their overall quality. In the past, we have proposed a catalog of refactorings for spreadsheet models expressed in the ClassSheets modeling language, which allows us to specify the business logic of a spreadsheet in an object-oriented fashion. Reasoning about spreadsheets...

Complexity Metrics for Spreadsheet Models

Several complexity metrics are described which are related to logic structure, data structure and size of spreadsheet models. They primarily concentrate on the dispersion of cell references and cell paths. Most metrics are newly defined, while some are adapted from traditional software engineering. Their purpose is the identification of cells which are liable to errors. In addition, they can be...

Refactoring Smelly Spreadsheet Models

Identifying bad design patterns in software is a successful and inspiring research trend. While these patterns do not necessarily correspond to software errors, the fact is that they raise potential problematic issues, often referred to as code smells, and that can for example compromise maintainability or evolution. The identification of code smells in spreadsheets, which can be viewed as soft...

Spreadsheet-based GIS Models

An auditing protocol for spreadsheet models